Release 10.1A: OpenEdge Data Management:
SQL Reference

DROP SYNONYM

Drops the specified synonym.

Syntax

DROP [ PUBLIC ] SYNONYM synonym ;

PUBLIC

Specifies that the synonym was created with the PUBLIC argument.

SYNONYM synonym

Name for the synonym.

Example

DROP SYNONYM customer ; DROP PUBLIC SYNONYM public_suppliers ;

Notes

If DROP SYNONYM specifies PUBLIC and the synonym was not a public synonym, SQL generates the “base table not found” error.
If DROP SYNONYM does not specify public and the synonym was created with the PUBLIC argument, SQL generates the “base table not found” error.

Authorization

Must have DBA privilege or ownership of the synonym (for DROP SYNONYM).

Related statements

CREATE SYNONYM